[dbo].[EventSetupGroup]

Property	Value
Created	10:31:20 AM Tuesday, March 02, 2010
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Created

10:31:20 AM Tuesday, March 02, 2010

Last Modified

11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_EventSetupGroup: EventCode\GroupName$	EventCode	varchar(15)	15
$Cluster Primary Key PK_EventSetupGroup: EventCode\GroupName$	GroupName	varchar(8)	8
	GroupLabel	varchar(64)	64
	GroupOrder	int	4
	GroupPageMessage	varchar(256)	256

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_EventSetupGroup: EventCode\GroupName$

EventCode

varchar(15)

$Cluster Primary Key PK_EventSetupGroup: EventCode\GroupName$

GroupName

varchar(8)

GroupLabel

varchar(64)

GroupOrder

int

GroupPageMessage

varchar(256)

256

	Name	Columns	Unique
$Cluster Primary Key PK_EventSetupGroup: EventCode\GroupName$	PK_EventSetupGroup	EventCode, GroupName

Name

Columns

Unique

$Cluster Primary Key PK_EventSetupGroup: EventCode\GroupName$

PK_EventSetupGroup

EventCode, GroupName

Name	Columns
FK_EventSetupGroup_EventSetupGeneral	EventCode->[dbo].[EventSetupGeneral].[EventCode]

Name

Columns

FK_EventSetupGroup_EventSetupGeneral

EventCode->[dbo].[EventSetupGeneral].[EventCode]

SQL Script

CREATE TABLE [dbo].[EventSetupGroup]
(
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GroupName] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GroupLabel] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GroupOrder] [int] NOT NULL,
[GroupPageMessage] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventSetupGroup] ADD CONSTRAINT [PK_EventSetupGroup] PRIMARY KEY CLUSTERED ([EventCode], [GroupName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventSetupGroup] ADD CONSTRAINT [FK_EventSetupGroup_EventSetupGeneral] FOREIGN KEY ([EventCode]) REFERENCES [dbo].[EventSetupGeneral] ([EventCode])
GO